﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true" CodeFile="Certificate.aspx.cs" Inherits="Train_Certificate" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Titile" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" Runat="Server">
 <InfoLight:WebDataSource ID="Master" runat="server" AutoApply="True" WebDataSetID="WMaster"
                DataMember="Train_Certificate">
            </InfoLight:WebDataSource>
            <InfoLight:WebDataSource ID="WEmp" runat="server" SelectAlias="Usasdb" SelectCommand="SELECT     &#13;&#10;Employees.EmployeeID, &#13;&#10;Employees.EmpName, &#13;&#10;CompanyJob.JobName, &#13;&#10;Department.DepartmentName&#13;&#10;FROM         &#13;&#10;Employees INNER JOIN&#13;&#10;                      Department ON Employees.DepartmentId = Department.DepartmentId                   INNER JOIN&#13;&#10;                      CompanyJob ON Employees.JobId = CompanyJob.JobId&#13;&#10;WHERE     (Employees.EmpStatus = 1)">
            </InfoLight:WebDataSource>
            <InfoLight:WebDefault ID="WebDefault1" runat="server" DataMember="Train_Certificate"
                DataSourceID="Master">
                <Fields>
                    <InfoLight:DefaultFieldItem DefaultValue="-1" FieldName="CertId" />
                </Fields>
            </InfoLight:WebDefault>
             <InfoLight:WebNavigator ID="WebNavigator1" runat="server" BindingObject="wgvMaster"
                Width="100%" StatusStrip="WebStatusStrip1" CssClass="NavigatorBar" 
        CtlHeight="25">
                <NavControls>
                    <InfoLight:ControlItem ControlName="Add" ControlText="穝糤" ControlType="Image" ControlVisible="True"
                        ImageUrl="../image/uipics/add_C.gif" MouseOverImageUrl="../image/uipics/add2_C.gif"
                        Size="48" disenableimageurl="../Image/UIPics/add3_C.gif"/>
                    <InfoLight:ControlItem ControlName="Apply" ControlText="郎" ControlType="Image" ControlVisible="True"
                        ImageUrl="../image/uipics/apply_C.gif" MouseOverImageUrl="../image/uipics/apply2_C.gif"
                        Size="48" disenableimageurl="../Image/UIPics/apply3_C.gif"/>
                    <InfoLight:ControlItem ControlName="Abort" ControlText="斌" ControlType="Image" ControlVisible="True"
                        ImageUrl="../image/uipics/abort_C.gif" MouseOverImageUrl="../image/uipics/abort2_C.gif"
                        Size="48" disenableimageurl="../Image/UIPics/abort3_C.gif"/>
                    <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                        ImageUrl="../image/uipics/query_C.gif" MouseOverImageUrl="../image/uipics/query2_C.gif"
                        Size="48" disenableimageurl="../Image/UIPics/query3_C.gif"/>
                </NavControls>
                <NavStates>
                    <InfoLight:WebNavigatorStateItem StateText="Initial" />
                    <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                    <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                    <InfoLight:WebNavigatorStateItem StateText="Editing" />
                    <InfoLight:WebNavigatorStateItem StateText="Applying" />
                    <InfoLight:WebNavigatorStateItem StateText="Changing" />
                    <InfoLight:WebNavigatorStateItem StateText="Querying" />
                    <InfoLight:WebNavigatorStateItem StateText="Printing" />
                </NavStates>
            </InfoLight:WebNavigator>
            <InfoLight:WebValidate ID="WebValidate1" runat="server" AltRowCss="" DataMember="Train_Certificate"
                DataSourceID="Master" ForeColor="Red" RowCss=""><Fields>
<InfoLight:ValidateFieldItem FieldName="EmployeeID" CheckNull="True"></InfoLight:ValidateFieldItem>
<InfoLight:ValidateFieldItem FieldName="CertName" CheckNull="True"></InfoLight:ValidateFieldItem>
<InfoLight:ValidateFieldItem FieldName="CertSDate" CheckNull="True"></InfoLight:ValidateFieldItem>
<InfoLight:ValidateFieldItem FieldName="CertEDate" CheckNull="True"></InfoLight:ValidateFieldItem>
</Fields>
</InfoLight:WebValidate>
<InfoLight:WebGridView ID="wgvMaster" runat="server" CellPadding="5" DataSourceID="Master"
            ForeColor="#333333" Width="100%" 
        AbortIconUrl="../Image/UIPics/Abort.gif" AddIconUrl="../Image/UIPics/Add.gif"
            ApplyIconUrl="../Image/UIPics/Apply.gif" CancelIconUrl="../Image/UIPics/Cancel.gif"
            MouseOverAbortIconUrl="../Image/UIPics/Abort2.gif" MouseOverAddIconUrl="../Image/UIPics/Add2.gif"
            MouseOverApplyIconUrl="../Image/UIPics/Apply2.gif" MouseOverCancelIconUrl="../Image/UIPics/Cancel2.gif"
            MouseOverOKIconUrl="../Image/UIPics/OK2.gif" MouseOverQueryIconUrl="../Image/UIPics/Query2.gif"
            OKIconUrl="../Image/UIPics/OK.gif" 
        QueryIconUrl="../Image/UIPics/Query.gif" HeaderStyleWrap="False"
            BackColor="White" BorderColor="White" BorderStyle="Groove" 
        BorderWidth="2px">
            <PagerSettings Mode="NumericFirstLast" />
            <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></FooterStyle>
            <NavControls>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif"
                    ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif">
                </InfoLight:ControlItem>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif"
                    ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif">
                </InfoLight:ControlItem>
                <InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif"
                    ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif">
                </InfoLight:ControlItem>
            </NavControls>
            <Columns>
                <asp:CommandField ButtonType="Image" CancelImageUrl="~/Image/UIPics/Cancel.gif" DeleteImageUrl="~/Image/UIPics/Delete.gif"
                    EditImageUrl="~/Image/UIPics/Edit.gif" SelectImageUrl="~/Image/UIPics/Select.gif"
                    ShowDeleteButton="True" ShowEditButton="True" UpdateImageUrl="~/Image/UIPics/OK.gif" />
                <asp:TemplateField HeaderText="编号" SortExpression="CertId">
                    <edititemtemplate>
<asp:Label id="Label1" runat="server" Width="64px" Text='<%# Bind("CertId") %>' __designer:wfdid="w9"></asp:Label>
</edititemtemplate>
                    <footertemplate>
<asp:Label id="Label1" runat="server" Width="64px" Text='<%# Bind("CertId") %>' __designer:wfdid="w10"></asp:Label>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label1" runat="server" Width="64px" Text='<%# Bind("CertId") %>' __designer:wfdid="w7"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="员工" SortExpression="EmployeeID">
                    <edititemtemplate>
<InfoLight:WebRefVal id="WebRefVal1" runat="server" DataSourceID="WEmp" Width="120px" __designer:wfdid="w17" ReadOnly="False" UseButtonImage="True" ResxDataSet ResxFilePath PostBackButonClick="False" BindingText MultiLanguage="False" UpdatePanelID DataBindingField="EmployeeID" AllowAddData="False" BindingValue='<%# Bind("EmployeeID") %>' ButtonImageUrl="../Image/refval/RefVal.gif" DataTextField="EmpName" DataValueField="EmployeeID"><Columns>
<InfoLight:WebRefColumn ColumnName="EmployeeID" HeadText="员工编号" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="EmpName" HeadText="员工姓名" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="JobName" HeadText="职务" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="DepartmentName" HeadText="部门名称" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal> 
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebRefVal id="WebRefVal1" runat="server" DataSourceID="WEmp" Width="120px" __designer:wfdid="w18" ReadOnly="False" UseButtonImage="True" ResxDataSet ResxFilePath PostBackButonClick="False" BindingText MultiLanguage="False" UpdatePanelID DataBindingField="EmployeeID" AllowAddData="False" BindingValue='<%# Bind("EmployeeID") %>' ButtonImageUrl="../Image/refval/RefVal.gif" DataTextField="EmpName" DataValueField="EmployeeID"><Columns>
<InfoLight:WebRefColumn ColumnName="EmployeeID" HeadText="员工编号" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="EmpName" HeadText="员工姓名" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="JobName" HeadText="职务" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn ColumnName="DepartmentName" HeadText="部门名称" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal> 
</footertemplate>
                    <itemtemplate>
<InfoLight:WebRefVal id="WebRefVal1" runat="server" DataSourceID="WEmp" Width="80px" BorderStyle="None" BorderColor="Transparent" BackColor="Transparent" __designer:wfdid="w16" ReadOnly="True" UseButtonImage="True" ResxDataSet ResxFilePath PostBackButonClick="False" BindingText MultiLanguage="False" UpdatePanelID DataBindingField="EmployeeID" AllowAddData="False" BindingValue='<%# Bind("EmployeeID") %>' ButtonImageUrl="../Image/refval/RefVal.gif" DataTextField="EmpName" DataValueField="EmployeeID"></InfoLight:WebRefVal> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="证书名称" SortExpression="CertName">
                    <edititemtemplate>
<asp:TextBox id="TextBox3" runat="server" Width="120px" Text='<%# Bind("CertName") %>' __designer:wfdid="w12"></asp:TextBox> 
</edititemtemplate>
                    <footertemplate>
<asp:TextBox id="TextBox3" runat="server" Width="120px" Text='<%# Bind("CertName") %>' __designer:wfdid="w13"></asp:TextBox>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label3" runat="server" Width="120px" Text='<%# Bind("CertName") %>' __designer:wfdid="w11"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="证件编号" SortExpression="CertificateNo">
                    <edititemtemplate>
<asp:TextBox id="TextBox4" runat="server" Width="120px" Text='<%# Bind("CertificateNo") %>' __designer:wfdid="w15"></asp:TextBox> 
</edititemtemplate>
                    <footertemplate>
<asp:TextBox id="TextBox4" runat="server" Width="120px" Text='<%# Bind("CertificateNo") %>' __designer:wfdid="w16"></asp:TextBox>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label4" runat="server" Width="120px" Text='<%# Bind("CertificateNo") %>' __designer:wfdid="w14"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="起始有效日期" SortExpression="CertSDate">
                    <edititemtemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker1" runat="server" Width="90px" Text='<%# Bind("CertSDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w59" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker> 
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker1" runat="server" Width="90px" Text='<%# Bind("CertSDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w64" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label5" runat="server" Width="120px" Text='<%# Bind("CertSDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w61"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="终止有效日期" SortExpression="CertEDate">
                    <edititemtemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker2" runat="server" Width="90px" Text='<%# Bind("CertEDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w56" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker> 
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker2" runat="server" Width="90px" Text='<%# Bind("CertEDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w68" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label6" runat="server" Width="120px" Text='<%# Bind("CertEDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w65"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="复审日期" SortExpression="CertRDate">
                    <edititemtemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker3" runat="server" Width="90px" Text='<%# Bind("CertRDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w53" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker> 
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebDateTimePicker id="WebDateTimePicker3" runat="server" Width="90px" Text='<%# Bind("CertRDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w72" UseButtonImage="True" DateFormat="ShortDate" DateTimeType="DateTime" MinYear="1950" MaxYear="2050" LocalizeForROC="False" Localize="False"></InfoLight:WebDateTimePicker>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label7" runat="server" Width="120px" Text='<%# Bind("CertRDate","{0:yyyy-MM-dd}") %>' __designer:wfdid="w40"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="培训备注" SortExpression="Mem">
                    <edititemtemplate>
<asp:TextBox id="TextBox8" runat="server" Text='<%# Bind("Mem") %>' __designer:wfdid="w31"></asp:TextBox> 
</edititemtemplate>
                    <footertemplate>
<asp:TextBox id="TextBox8" runat="server" Text='<%# Bind("Mem") %>' __designer:wfdid="w32"></asp:TextBox>
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label8" runat="server" Text='<%# Bind("Mem") %>' __designer:wfdid="w30"></asp:Label> 
</itemtemplate>
                </asp:TemplateField>
            </Columns>
            <RowStyle BackColor="#EFF3FB"></RowStyle>
            <EditRowStyle BackColor="#2461BF"></EditRowStyle>
            <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"></SelectedRowStyle>
            <PagerStyle BackColor="LightBlue" ForeColor="White" HorizontalAlign="Center"></PagerStyle>
            <HeaderStyle BackColor="DeepSkyBlue" ForeColor="White" Font-Bold="True"></HeaderStyle>
            <AlternatingRowStyle BackColor="White" BorderColor="White"></AlternatingRowStyle>
            <AddNewRowControls>
                <InfoLight:AddNewRowControlItem ControlID="Label1" ControlType="Label" FieldName="CertId" />
                <InfoLight:AddNewRowControlItem ControlID="WebRefVal1" ControlType="RefVal" FieldName="EmployeeID" />
                <InfoLight:AddNewRowControlItem ControlID="TextBox3" ControlType="TextBox" FieldName="CertName" />
                <InfoLight:AddNewRowControlItem ControlID="TextBox4" ControlType="TextBox" FieldName="CertificateNo" />
                <InfoLight:AddNewRowControlItem ControlID="WebDateTimePicker1" ControlType="DateTimePicker"
                    FieldName="CertSDate" />
                <InfoLight:AddNewRowControlItem ControlID="WebDateTimePicker2" ControlType="DateTimePicker"
                    FieldName="CertEDate" />
                <InfoLight:AddNewRowControlItem ControlID="WebDateTimePicker3" ControlType="DateTimePicker"
                    FieldName="CertRDate" />
                <InfoLight:AddNewRowControlItem ControlID="TextBox8" ControlType="TextBox" FieldName="Mem" />
            </AddNewRowControls>
        </InfoLight:WebGridView>
</asp:Content>

